
<!DOCTYPE HTML>
<html lang="zh-hans" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>MySQL/MariaDB基础 · AGou's StudyNote</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="AGou">
        
        
    
    <link rel="stylesheet" href="../../gitbook/style.css">

    
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-anchors/plugin.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-tbfed-pagefooter/footer.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-expandable-chapters-small/expandable-chapters-small.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-anchor-navigation-ex/style/plugin.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-prism/prism-tomorrow.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-insert-logo/plugin.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-search-pro/search.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-splitter/splitter.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-lightbox/css/lightbox.min.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-donate/plugin.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-code/plugin.css">
                
            
                
                <link rel="stylesheet" href="../../gitbook/gitbook-plugin-fontsettings/website.css">
                
            
        

    

    
        
    
        
    
        
    
        
    
        
    
        
    

        
    
    
    
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../../gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="../../gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="php-mysql.html" />
    
    
    <link rel="prev" href="README.md" />
    

    <style>
    @media only screen and (max-width: 640px) {
        .book-header .hidden-mobile {
            display: none;
        }
    }
    </style>
    <script>
        window["gitbook-plugin-github-buttons"] = {"repo":"AGou-ops/myStudyNote","types":["star","watch","fork"],"size":"small"};
    </script>

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
<div id="book-search-input" role="search">
    <input type="text" placeholder="输入并搜索" />
</div>

            
                <nav role="navigation">
                


<ul class="summary">
    
    
    
        
        <li>
            <a href="http://agou-ops.github.io" target="_blank" class="custom-link">◆点击进入我的个人博客</a>
        </li>
    
    

    
    <li class="divider"></li>
    

    
        
        
    
        <li class="chapter " data-level="1.1" data-path="../../">
            
                <a href="../../">
            
                    
                        <b>1.1.</b>
                    
                    关于我
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2" data-path="../../Program_lang/">
            
                <a href="../../Program_lang/">
            
                    
                        <b>1.2.</b>
                    
                    编程语言
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.2.1" data-path="../../Program_lang/Python.html">
            
                <a href="../../Program_lang/Python.html">
            
                    
                        <b>1.2.1.</b>
                    
                    Python
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.2" data-path="../../Program_lang/Java.html">
            
                <a href="../../Program_lang/Java.html">
            
                    
                        <b>1.2.2.</b>
                    
                    Java
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.3" data-path="../../Program_lang/Splash_Lua.html">
            
                <a href="../../Program_lang/Splash_Lua.html">
            
                    
                        <b>1.2.3.</b>
                    
                    Splash_Lua
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.3" data-path="../">
            
                <a href="../">
            
                    
                        <b>1.3.</b>
                    
                    数据库
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.3.1" data-path="README.md">
            
                <span>
            
                    
                        <b>1.3.1.</b>
                    
                    Mysql/MariaDB
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter active" data-level="1.3.1.1" data-path="MySQL、MariaDB基础.html">
            
                <a href="MySQL、MariaDB基础.html">
            
                    
                        <b>1.3.1.1.</b>
                    
                    MySQL/MariaDB基础
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.1.2" data-path="php-mysql.html">
            
                <a href="php-mysql.html">
            
                    
                        <b>1.3.1.2.</b>
                    
                    php-mysql
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.3.2" data-path="../MongoDB.html">
            
                <a href="../MongoDB.html">
            
                    
                        <b>1.3.2.</b>
                    
                    MongoDB
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.3" data-path="../Redis.html">
            
                <a href="../Redis.html">
            
                    
                        <b>1.3.3.</b>
                    
                    Redis
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.4" data-path="../../Linux/">
            
                <a href="../../Linux/">
            
                    
                        <b>1.4.</b>
                    
                    Linux
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.4.1" data-path="../../Linux/Linux基础.html">
            
                <a href="../../Linux/Linux基础.html">
            
                    
                        <b>1.4.1.</b>
                    
                    Linux基础
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.2" data-path="../../Linux/Linux启动流程、内核、grub、模块、内核的编译、anaconda自动化.html">
            
                <a href="../../Linux/Linux启动流程、内核、grub、模块、内核的编译、anaconda自动化.html">
            
                    
                        <b>1.4.2.</b>
                    
                    Linux启动流程、内核、grub、模块等
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.3" data-path="../../Linux/Linux服务器.html">
            
                <a href="../../Linux/Linux服务器.html">
            
                    
                        <b>1.4.3.</b>
                    
                    Linux服务器
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.4" data-path="../../Linux/Linux状态信息.html">
            
                <a href="../../Linux/Linux状态信息.html">
            
                    
                        <b>1.4.4.</b>
                    
                    Linux状态信息
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.5" data-path="../../Linux/Linux网络客户端工具.html">
            
                <a href="../../Linux/Linux网络客户端工具.html">
            
                    
                        <b>1.4.5.</b>
                    
                    Linux网络客户端工具
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.6" data-path="../../Linux/Linux网络配置.html">
            
                <a href="../../Linux/Linux网络配置.html">
            
                    
                        <b>1.4.6.</b>
                    
                    Linux网络配置
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.7" data-path="../../Linux/Linux配置文件.md">
            
                <span>
            
                    
                        <b>1.4.7.</b>
                    
                    Linux配置文件
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.8" data-path="../../Linux/Linux时间服务器.html">
            
                <a href="../../Linux/Linux时间服务器.html">
            
                    
                        <b>1.4.8.</b>
                    
                    Linux时间服务器
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.9" data-path="../../Linux/Linux日志管理系统.html">
            
                <a href="../../Linux/Linux日志管理系统.html">
            
                    
                        <b>1.4.9.</b>
                    
                    Linux日志管理系统
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.10" data-path="../../Linux/sudo详解.html">
            
                <a href="../../Linux/sudo详解.html">
            
                    
                        <b>1.4.10.</b>
                    
                    sudo详解
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.11" data-path="../../Linux/SElinux.html">
            
                <a href="../../Linux/SElinux.html">
            
                    
                        <b>1.4.11.</b>
                    
                    SELinux
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.12" data-path="../../Linux/iptables.html">
            
                <a href="../../Linux/iptables.html">
            
                    
                        <b>1.4.12.</b>
                    
                    iptables
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.13" data-path="../../Linux/Linux_shell.html">
            
                <a href="../../Linux/Linux_shell.html">
            
                    
                        <b>1.4.13.</b>
                    
                    Linux Shell
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.14" data-path="../../Linux/shell_awk.html">
            
                <a href="../../Linux/shell_awk.html">
            
                    
                        <b>1.4.14.</b>
                    
                    shell_awk
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.15" data-path="../../Linux/OpenSSL、PKI搭建、算法.html">
            
                <a href="../../Linux/OpenSSL、PKI搭建、算法.html">
            
                    
                        <b>1.4.15.</b>
                    
                    OpenSSL、PKI搭建
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.16" data-path="../../Linux/DNS服务器.html">
            
                <a href="../../Linux/DNS服务器.html">
            
                    
                        <b>1.4.16.</b>
                    
                    DNS服务器
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.17" data-path="../../Linux/Frp内网穿透.html">
            
                <a href="../../Linux/Frp内网穿透.html">
            
                    
                        <b>1.4.17.</b>
                    
                    Frp内网穿透
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.18" data-path="../../Linux/Linux其他.md">
            
                <span>
            
                    
                        <b>1.4.18.</b>
                    
                    Linux其他
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.5" data-path="../../Linux_FileSystem/">
            
                <a href="../../Linux_FileSystem/">
            
                    
                        <b>1.5.</b>
                    
                    Linux文件系统
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.5.1" data-path="../../Linux_FileSystem/FTP.html">
            
                <a href="../../Linux_FileSystem/FTP.html">
            
                    
                        <b>1.5.1.</b>
                    
                    FTP
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.2" data-path="../../Linux_FileSystem/SAMBA.html">
            
                <a href="../../Linux_FileSystem/SAMBA.html">
            
                    
                        <b>1.5.2.</b>
                    
                    SAMBA
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.6" data-path="../../Linux_Tools/">
            
                <a href="../../Linux_Tools/">
            
                    
                        <b>1.6.</b>
                    
                    Linux工具
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.6.1" data-path="../../Linux_Tools/fzf工具.html">
            
                <a href="../../Linux_Tools/fzf工具.html">
            
                    
                        <b>1.6.1.</b>
                    
                    fzf工具
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.2" data-path="../../Linux_Tools/工具集合.html">
            
                <a href="../../Linux_Tools/工具集合.html">
            
                    
                        <b>1.6.2.</b>
                    
                    Linux工具集合
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7" data-path="../../WEB_Server/">
            
                <a href="../../WEB_Server/">
            
                    
                        <b>1.7.</b>
                    
                    网站服务器
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1" data-path="../../WEB_Server/HTML基础.html">
            
                <a href="../../WEB_Server/HTML基础.html">
            
                    
                        <b>1.7.1.</b>
                    
                    HTML基础
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.2" data-path="../../WEB_Server/WEB基础.html">
            
                <a href="../../WEB_Server/WEB基础.html">
            
                    
                        <b>1.7.2.</b>
                    
                    WEB基础
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.3" data-path="../../WEB_Server/httpd.html">
            
                <a href="../../WEB_Server/httpd.html">
            
                    
                        <b>1.7.3.</b>
                    
                    httpd/Apache
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.4" data-path="../../WEB_Server/httpd.conf文件详解.html">
            
                <a href="../../WEB_Server/httpd.conf文件详解.html">
            
                    
                        <b>1.7.4.</b>
                    
                    httpd.conf文件详解
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.5" data-path="../../WEB_Server/Nginx.html">
            
                <a href="../../WEB_Server/Nginx.html">
            
                    
                        <b>1.7.5.</b>
                    
                    Nginx
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.6" data-path="../../WEB_Server/HTTP状态码-详情.html">
            
                <a href="../../WEB_Server/HTTP状态码-详情.html">
            
                    
                        <b>1.7.6.</b>
                    
                    HTTP状态码-详情
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.8" data-path="../../Common_Framework/">
            
                <a href="../../Common_Framework/">
            
                    
                        <b>1.8.</b>
                    
                    常用框架
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.8.1" data-path="../../Common_Framework/LNMP.html">
            
                <a href="../../Common_Framework/LNMP.html">
            
                    
                        <b>1.8.1.</b>
                    
                    LNMP
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.8.2" data-path="../../Common_Framework/LAMP.html">
            
                <a href="../../Common_Framework/LAMP.html">
            
                    
                        <b>1.8.2.</b>
                    
                    LAMP
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.9" data-path="../../Docker&K8s/">
            
                <a href="../../Docker&K8s/">
            
                    
                        <b>1.9.</b>
                    
                    容器及容器编排
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.9.1" data-path="../../Docker&K8s/Docker/Docker.html">
            
                <a href="../../Docker&K8s/Docker/Docker.html">
            
                    
                        <b>1.9.1.</b>
                    
                    Docker
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.9.1.1" data-path="../../Docker&K8s/Docker/Docker.html">
            
                <a href="../../Docker&K8s/Docker/Docker.html">
            
                    
                        <b>1.9.1.1.</b>
                    
                    Docker
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.9.2" data-path="../../Docker&K8s/K8s/">
            
                <a href="../../Docker&K8s/K8s/">
            
                    
                        <b>1.9.2.</b>
                    
                    K8s
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.9.2.1" data-path="../../Docker&K8s/K8s/K8s基础知识.html">
            
                <a href="../../Docker&K8s/K8s/K8s基础知识.html">
            
                    
                        <b>1.9.2.1.</b>
                    
                    K8s基础知识
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.9.2.2" data-path="../../Docker&K8s/K8s/K8s安装与部署.html">
            
                <a href="../../Docker&K8s/K8s/K8s安装与部署.html">
            
                    
                        <b>1.9.2.2.</b>
                    
                    K8s安装与部署
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.10" data-path="../../Git/">
            
                <a href="../../Git/">
            
                    
                        <b>1.10.</b>
                    
                    Git
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.10.1" data-path="../../Git/Git基础.html">
            
                <a href="../../Git/Git基础.html">
            
                    
                        <b>1.10.1.</b>
                    
                    Git基础
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.10.2" data-path="../../Git/GitLab服务器.html">
            
                <a href="../../Git/GitLab服务器.html">
            
                    
                        <b>1.10.2.</b>
                    
                    GitLab服务器
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.11" data-path="../../Windows/">
            
                <a href="../../Windows/">
            
                    
                        <b>1.11.</b>
                    
                    Windows系统
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.11.1" data-path="../../Windows/cmd命令.html">
            
                <a href="../../Windows/cmd命令.html">
            
                    
                        <b>1.11.1.</b>
                    
                    cmd命令
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.12" data-path="../../Vim.html">
            
                <a href="../../Vim.html">
            
                    
                        <b>1.12.</b>
                    
                    Vim
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13" data-path="../../i3WM快捷键.html">
            
                <a href="../../i3WM快捷键.html">
            
                    
                        <b>1.13.</b>
                    
                    i3WM快捷键
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14" data-path="../../ADB命令.html">
            
                <a href="../../ADB命令.html">
            
                    
                        <b>1.14.</b>
                    
                    ADB命令
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.15" data-path="../../Tmux.html">
            
                <a href="../../Tmux.html">
            
                    
                        <b>1.15.</b>
                    
                    Tmux
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.16" data-path="../../Kindle.html">
            
                <a href="../../Kindle.html">
            
                    
                        <b>1.16.</b>
                    
                    Kindle越狱指南
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.17" data-path="../../Other/">
            
                <a href="../../Other/">
            
                    
                        <b>1.17.</b>
                    
                    Other
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.17.1" data-path="../../Other/pandoc.html">
            
                <a href="../../Other/pandoc.html">
            
                    
                        <b>1.17.1.</b>
                    
                    pandoc
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.17.2" data-path="../../Other/jupyter&reveal.js.html">
            
                <a href="../../Other/jupyter&reveal.js.html">
            
                    
                        <b>1.17.2.</b>
                    
                    jupyter & reveal.js
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.17.3" data-path="../../Other/json.html">
            
                <a href="../../Other/json.html">
            
                    
                        <b>1.17.3.</b>
                    
                    json
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.17.4" data-path="../../Other/Reveal_js.html">
            
                <a href="../../Other/Reveal_js.html">
            
                    
                        <b>1.17.4.</b>
                    
                    Reveal_js
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            本书使用 GitBook 发布
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    

<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href="../.." >MySQL/MariaDB基础</a>
    </h1>
</div>




                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
<div id="book-search-results">
    <div class="search-noresults">
    
                                <section class="normal markdown-section">
                                
                                <div id="anchor-navigation-ex-navbar"><i class="fa fa-anchor"></i><ul><li><a href="#mysql">1. MySQL</a></li><ul><li><a href="#&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;">1.1. &#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;</a></li><li><a href="#&#x7528;&#x6237;&#x7BA1;&#x7406;">1.2. &#x7528;&#x6237;&#x7BA1;&#x7406;</a></li><li><a href="#&#x67E5;&#x8BE2;&#x6570;&#x636E;">1.3. &#x67E5;&#x8BE2;&#x6570;&#x636E;</a></li><li><a href="#&#x4FEE;&#x6539;&#x6570;&#x636E;">1.4. &#x4FEE;&#x6539;&#x6570;&#x636E;</a></li><li><a href="#php&#x8FDE;&#x63A5;&#x4F7F;&#x7528;mysql">1.5. php&#x8FDE;&#x63A5;&#x4F7F;&#x7528;mysql</a></li></ul><li><a href="#mariadb">2. MariaDB</a></li><ul><li><a href="#mariadb&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;">2.1. MariaDB&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;</a></li></ul><li><a href="#&#x7B80;&#x5355;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF1A;phpmyadmin">3. &#x7B80;&#x5355;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF1A;phpMyAdmin</a></li><li><a href="#&#x5176;&#x4ED6;">4. &#x5176;&#x4ED6;</a></li><ul><li><a href="#mysql&#x91CD;&#x7F6E;&#x5BC6;&#x7801;">4.1. Mysql&#x91CD;&#x7F6E;&#x5BC6;&#x7801;</a></li><li><a href="#mysql&#x547D;&#x4EE4;&#x884C;&#x795E;&#x5668;mycli">4.2. MySQL&#x547D;&#x4EE4;&#x884C;&#x795E;&#x5668;MyCLI</a></li><ul><li><a href="#&#x5B89;&#x88C5;">4.2.1. &#x5B89;&#x88C5;</a></li><li><a href="#&#x4F7F;&#x7528;">4.2.2. &#x4F7F;&#x7528;</a></li></ul><li><a href="#sql&#x5728;&#x7EBF;&#x7EC3;&#x4E60;&#x7F51;&#x7AD9;">4.3. SQL&#x5728;&#x7EBF;&#x7EC3;&#x4E60;&#x7F51;&#x7AD9;</a></li></ul></ul></div><a href="#mysql" id="anchorNavigationExGoTop"><i class="fa fa-arrow-up"></i></a><blockquote>
<p><strong>This is Mysql&#x3001;MariaDB&#x57FA;&#x7840; StudyNote.</strong></p>
</blockquote>
<h1 id="mysql"><a name="mysql" class="anchor-navigation-ex-anchor" href="#mysql"><i class="fa fa-link" aria-hidden="true"></i></a>1. MySQL</h1>
<blockquote>
<p>MySQL&#x662F;&#x4E00;&#x4E2A;<strong>&#x5173;&#x7CFB;&#x578B;&#x6570;&#x636E;&#x5E93;&#x7BA1;&#x7406;&#x7CFB;&#x7EDF;</strong>&#xFF0C;&#x7531;&#x745E;&#x5178;MySQL AB &#x516C;&#x53F8;&#x5F00;&#x53D1;&#xFF0C;&#x76EE;&#x524D;&#x5C5E;&#x4E8E; Oracle &#x65D7;&#x4E0B;&#x4EA7;&#x54C1;&#x3002;</p>
<p>&#x5B98;&#x65B9;&#x7AD9;&#x70B9;&#xFF1A;<a href="https://www.mysql.com/" target="_blank">https://www.mysql.com/</a></p>
</blockquote>
<h2 id="&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;"><a name="&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;" class="anchor-navigation-ex-anchor" href="#&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;"><i class="fa fa-link" aria-hidden="true"></i></a>1.1. &#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;</h2>
<p>&#x5B89;&#x88C5;&#x542F;&#x52A8;&#x4E0E;&#x7B80;&#x5355;&#x8BBE;&#x7F6E;</p>
<pre class="language-"><code class="lang-bash"><span class="token comment"># &#x83B7;&#x53D6;&#x5B98;&#x7F51;RPM&#x6587;&#x4EF6;</span>
<span class="token function">wget</span> http://repo.mysql.com/<span class="token punctuation">[</span>mysql80-community-release-el7-3.noarch.rpm<span class="token punctuation">]</span>
<span class="token comment"># &#x6821;&#x9A8C;rpm&#x6587;&#x4EF6;</span>
<span class="token function">rpm</span> -ivh mysql-community-release-el7-5.noarch.rpm
<span class="token comment"># &#x66F4;&#x65B0;&#x4E0B;&#x8F7D;</span>
yum update
<span class="token comment"># &#x5B89;&#x88C5;MySQL&#x670D;&#x52A1;</span>
yum <span class="token function">install</span> mysql-server
<span class="token comment"># &#x6743;&#x9650;&#x8BBE;&#x7F6E;</span>
<span class="token function">chown</span> mysql:mysql -R /var/lib/mysql

<span class="token comment"># &#x521D;&#x59CB;&#x5316;Mysql</span>
mysqld --initialize
<span class="token comment"># &#x542F;&#x52A8;mysql&#x670D;&#x52A1;</span>
systemctl start mysqld

<span class="token comment"># &#x5173;&#x95ED;mysql&#x670D;&#x52A1;</span>
systemctl stop mysqld
<span class="token comment"># &#x6216;&#x8005;</span>
mysqladmin -uroot -p <span class="token function">shutdown</span>
</code></pre>
<p>&#x9A8C;&#x8BC1;&#x5B89;&#x88C5;&#x53CA;&#x7B80;&#x5355;&#x4F7F;&#x7528;</p>
<pre class="language-"><code class="lang-bash"><span class="token comment">#&#x3000;&#x67E5;&#x770B;mysql&#x7248;&#x672C;</span>
mysqladmin --version
<span class="token comment"># &#x521B;&#x5EFA;root&#x9ED8;&#x8BA4;&#x5BC6;&#x7801;</span>
mysqladmin -u root password <span class="token string">&quot;your_new_passwd&quot;</span><span class="token punctuation">;</span>

<span class="token comment"># &#x4F7F;&#x7528;</span>
mysql -uroot -p
</code></pre>
<h2 id="&#x7528;&#x6237;&#x7BA1;&#x7406;"><a name="&#x7528;&#x6237;&#x7BA1;&#x7406;" class="anchor-navigation-ex-anchor" href="#&#x7528;&#x6237;&#x7BA1;&#x7406;"><i class="fa fa-link" aria-hidden="true"></i></a>1.2. &#x7528;&#x6237;&#x7BA1;&#x7406;</h2>
<p>&#x6DFB;&#x52A0;&#x7528;&#x6237;&#x5B9E;&#x4F8B;&#xFF0C;&#x7528;&#x6237;&#x540D;&#x4E3A;<code>suofeiya</code>&#x6307;&#x5B9A;&#x5176;&#x5BC6;&#x7801;&#x4E3A;<code>suofeiya</code>&#xFF0C;&#x5E76;&#x6388;&#x4E88;&#x5176;<code>SELECT</code>&#x6743;&#x9650;&#xFF1A;</p>
<pre class="language-"><code class="lang-mysql"># &#x65B9;&#x5F0F;&#x4E00;&#xFF1A;
mysql&gt; use mysql;
mysql&gt; INSERT INTO user 
          (host, user, password, 
           select_priv) 
           VALUES (&apos;localhost&apos;, &apos;suofeiya&apos;, 
           PASSWORD(&apos;suofeiya&apos;), &apos;Y&apos;, &apos;Y&apos;, &apos;Y&apos;);
 # &#x91CD;&#x8F7D;&#x6388;&#x6743;&#x8868;
mysql&gt; FLUSH PRIVILEGES;
# &#x67E5;&#x770B;
mysql&gt; SELECT host, user, password FROM user WHERE user = &apos;suofeiya&apos;;
* &#x9700;&#x8981;&#x6CE8;&#x610F;&#x7684;&#x662F;&#xFF0C;`password()`&#x52A0;&#x5BC6;&#x51FD;&#x6570;&#x5728;mysql8&#x4E2D;&#x5DF2;&#x88AB;&#x79FB;&#x9664;&#xFF0C;&#x53EF;&#x4EE5;&#x4F7F;&#x7528;`MD5()`&#x51FD;&#x6570;&#x6765;&#x4EE3;&#x66FF;

# &#x65B9;&#x5F0F;&#x4E8C;&#xFF08;MySQL8.0&#x4E4B;&#x540E;&#xFF09;&#xFF1A;
mysql&gt; CREATE USER &apos;suofeiya&apos;@&apos;%&apos; IDENTIFIED BY &apos;suofeiya&apos;;
# &#x6388;&#x4E88;&#x90E8;&#x5206;&#x6743;&#x9650;
mysql&gt; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO &apos;suofeiya&apos;@&apos;%&apos;;
# &#x6388;&#x4E88;&#x6240;&#x6709;&#x6743;&#x9650;
mysql&gt; GRANT ALL PRIVILEGES ON *.* TO &apos;suofeiya&apos;@&apos;%&apos;;
mysql&gt; FLUSH PRIVILEGES;
# &#x67E5;&#x770B;&#x7528;&#x6237;&#x6743;&#x9650;
mysql&gt; SHOW GRANTS FOR &apos;suofeiya&apos;@&apos;%&apos;;
</code></pre>
<h2 id="&#x67E5;&#x8BE2;&#x6570;&#x636E;"><a name="&#x67E5;&#x8BE2;&#x6570;&#x636E;" class="anchor-navigation-ex-anchor" href="#&#x67E5;&#x8BE2;&#x6570;&#x636E;"><i class="fa fa-link" aria-hidden="true"></i></a>1.3. &#x67E5;&#x8BE2;&#x6570;&#x636E;</h2>
<h2 id="&#x4FEE;&#x6539;&#x6570;&#x636E;"><a name="&#x4FEE;&#x6539;&#x6570;&#x636E;" class="anchor-navigation-ex-anchor" href="#&#x4FEE;&#x6539;&#x6570;&#x636E;"><i class="fa fa-link" aria-hidden="true"></i></a>1.4. &#x4FEE;&#x6539;&#x6570;&#x636E;</h2>
<h2 id="php&#x8FDE;&#x63A5;&#x4F7F;&#x7528;mysql"><a name="php&#x8FDE;&#x63A5;&#x4F7F;&#x7528;mysql" class="anchor-navigation-ex-anchor" href="#php&#x8FDE;&#x63A5;&#x4F7F;&#x7528;mysql"><i class="fa fa-link" aria-hidden="true"></i></a>1.5. php&#x8FDE;&#x63A5;&#x4F7F;&#x7528;mysql</h2>
<p><a href="php-mysql.html">php-mysql</a></p>
<h1 id="mariadb"><a name="mariadb" class="anchor-navigation-ex-anchor" href="#mariadb"><i class="fa fa-link" aria-hidden="true"></i></a>2. MariaDB</h1>
<blockquote>
<p>MariaDB&#x6570;&#x636E;&#x5E93;&#x7BA1;&#x7406;&#x7CFB;&#x7EDF;&#x662F;MySQL&#x7684;&#x4E00;&#x4E2A;&#x5206;&#x652F;&#xFF0C;&#x4E3B;&#x8981;&#x7531;&#x5F00;&#x6E90;&#x793E;&#x533A;&#x5728;&#x7EF4;&#x62A4;&#xFF0C;&#x91C7;&#x7528;GPL&#x6388;&#x6743;&#x8BB8;&#x53EF; MariaDB&#x7684;&#x76EE;&#x7684;&#x662F;&#x5B8C;&#x5168;&#x517C;&#x5BB9;MySQL&#xFF0C;&#x5305;&#x62EC;API&#x548C;&#x547D;&#x4EE4;&#x884C;&#xFF0C;&#x4F7F;&#x4E4B;&#x80FD;&#x8F7B;&#x677E;&#x6210;&#x4E3A;MySQL&#x7684;&#x4EE3;&#x66FF;&#x54C1;&#x3002;</p>
<p>&#x5B98;&#x65B9;&#x7AD9;&#x70B9;&#xFF1A;<a href="https://mariadb.org/" target="_blank">https://mariadb.org/</a></p>
</blockquote>
<h2 id="mariadb&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;"><a name="mariadb&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;" class="anchor-navigation-ex-anchor" href="#mariadb&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;"><i class="fa fa-link" aria-hidden="true"></i></a>2.1. MariaDB&#x5B89;&#x88C5;&#x4E0E;&#x7B80;&#x5355;&#x4F7F;&#x7528;</h2>
<pre class="language-"><code class="lang-bash">yum <span class="token function">install</span> -y mariadb-server
<span class="token comment"># &#x4F7F;&#x7528;</span>
mysql -uroot -p
</code></pre>
<p><code>MariaDB</code>&#x4E3B;&#x8981;&#x7531;&#x4E24;&#x7C7B;&#x7A0B;&#x5E8F;&#x6587;&#x4EF6;&#xFF1A;</p>
<ul>
<li>Client&#xFF1A;<code>mysql</code>&#x3001;<code>mysqldump</code>&#x3001;<code>mysqladmin</code></li>
<li>Server&#xFF1A;<code>mysqld</code>&#x3001;<code>mysqld_safe</code>&#x3001;<code>mysqld_multi</code></li>
</ul>
<h1 id="&#x7B80;&#x5355;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF1A;phpmyadmin"><a name="&#x7B80;&#x5355;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF1A;phpmyadmin" class="anchor-navigation-ex-anchor" href="#&#x7B80;&#x5355;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF1A;phpmyadmin"><i class="fa fa-link" aria-hidden="true"></i></a>3. &#x7B80;&#x5355;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF1A;phpMyAdmin</h1>
<blockquote>
<p>phpMyAdmin &#x662F;&#x4E00;&#x4E2A;&#x4EE5;PHP&#x4E3A;&#x57FA;&#x7840;&#xFF0C;&#x4EE5;Web-Base&#x65B9;&#x5F0F;&#x67B6;&#x6784;&#x5728;&#x7F51;&#x7AD9;&#x4E3B;&#x673A;&#x4E0A;&#x7684;MySQL&#x7684;&#x6570;&#x636E;&#x5E93;&#x7BA1;&#x7406;&#x5DE5;&#x5177;&#xFF0C;&#x8BA9;&#x7BA1;&#x7406;&#x8005;&#x53EF;&#x7528;Web&#x63A5;&#x53E3;&#x7BA1;&#x7406;MySQL&#x6570;&#x636E;&#x5E93;&#x3002;</p>
<p>&#x5B98;&#x65B9;&#x7AD9;&#x70B9;&#xFF1A;<a href="https://www.phpmyadmin.net/" target="_blank">https://www.phpmyadmin.net/</a></p>
</blockquote>
<p>&#x4E3A;&#x4E86;&#x5B89;&#x5168;&#xFF0C;&#x505A;&#x4E9B;&#x8BB8;&#x4FEE;&#x6539;</p>
<pre class="language-"><code class="lang-bash"><span class="token comment"># &#x590D;&#x5236;&#x914D;&#x7F6E;&#x6587;&#x4EF6;&#x6A21;&#x677F;</span>
<span class="token function">cp</span> config.sample.inc.php config.inc.php
<span class="token comment"># &#x4FEE;&#x6539;&#x6A21;&#x677F;</span>
<span class="token function">vim</span> config.inc.php
<span class="token comment"># &#x4FEE;&#x6539;&#x5E76;&#x968F;&#x610F;&#x7ED9;&#x51FA;&#x5B57;&#x7B26;&#x4E32;&#x5373;&#x53EF;</span>
<span class="token variable">$cfg</span><span class="token punctuation">[</span><span class="token string">&apos;blowfish_secret&apos;</span><span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token string">&apos;fGCXVdsf3423432dfds&apos;</span><span class="token punctuation">;</span> /* YOU MUST FILL IN THIS FOR COOKIE AUTH<span class="token operator">!</span> */
</code></pre>
<h1 id="&#x5176;&#x4ED6;"><a name="&#x5176;&#x4ED6;" class="anchor-navigation-ex-anchor" href="#&#x5176;&#x4ED6;"><i class="fa fa-link" aria-hidden="true"></i></a>4. &#x5176;&#x4ED6;</h1>
<h2 id="mysql&#x91CD;&#x7F6E;&#x5BC6;&#x7801;"><a name="mysql&#x91CD;&#x7F6E;&#x5BC6;&#x7801;" class="anchor-navigation-ex-anchor" href="#mysql&#x91CD;&#x7F6E;&#x5BC6;&#x7801;"><i class="fa fa-link" aria-hidden="true"></i></a>4.1. Mysql&#x91CD;&#x7F6E;&#x5BC6;&#x7801;</h2>
<p>&#x5982;&#x679C;&#x5FD8;&#x8BB0;&#x5BC6;&#x7801;&#xFF0C;&#x53EF;&#x4EE5;&#x5728;<code>/etc/my.cnf</code>&#x914D;&#x7F6E;&#x6587;&#x4EF6;&#x4E2D;&#x52A0;&#x5165;<code>skip-grant-tables</code>&#x6765;&#x91CD;&#x7F6E;&#x5BC6;&#x7801;&#xFF0C;&#x6B65;&#x9AA4;&#x5982;&#x4E0B;&#xFF1A;</p>
<ol>
<li>&#x4FEE;&#x6539;&#x914D;&#x7F6E;&#x6587;&#x4EF6;</li>
</ol>
<pre class="language-"><code class="lang-bash"><span class="token function">vim</span> /etc/my.cnf
<span class="token comment">####</span>
<span class="token punctuation">..</span>.
<span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span>
skip-grant-tables
<span class="token assign-left variable">port</span><span class="token operator">=</span><span class="token number">3306</span>
<span class="token punctuation">..</span>.
<span class="token comment">####</span>
</code></pre>
<ol>
<li><p>&#x91CD;&#x542F;mysql&#x670D;&#x52A1;<code>systemctl restart mysql</code></p>
</li>
<li><p>&#x767B;&#x5F55;mysql&#xFF0C;&#x5E76;&#x4FEE;&#x6539;root&#x5BC6;&#x7801;</p>
</li>
</ol>
<pre class="language-"><code class="lang-mysql">mysql -uroot -p                # &#x6B64;&#x65F6;&#x767B;&#x5F55;&#x65E0;&#x9700;&#x8F93;&#x5165;&#x5BC6;&#x7801;&#xFF0C;&#x53EF;&#x76F4;&#x63A5;&#x767B;&#x5F55;&#x6210;&#x529F;
# &#x4FEE;&#x6539;root&#x5BC6;&#x7801;
mysql &gt; use mysql;
mysql&gt; update user set authentication_string=password(&quot;newpasswd&quot;) where user=&apos;root&apos;;
mysql&gt; flush privileges;

* &#x5982;&#x679C;&#x8FD8;&#x662F;&#x672A;&#x4FEE;&#x6539;&#x6210;&#x529F;&#xFF0C;&#x5728;password&#x4E4B;&#x540E;&#x52A0;&#x5165;`,plugin=&apos;mysql_native_password&apos;`&#x8BD5;&#x8BD5;
</code></pre>
<p>&#x6309;&#x7167;&#x6B64;&#x79CD;&#x65B9;&#x6CD5;&#xFF0C;&#x53EF;&#x4EE5;&#x5148;&#x5173;&#x95ED;mysql&#x670D;&#x52A1;&#xFF0C;&#x7136;&#x540E;&#x627E;&#x5230;mysql&#x7684;&#x4E3B;&#x7A0B;&#x5E8F;&#x6587;&#x4EF6;&#xFF0C;&#x52A0;&#x5165;<code>--skip-grant-tables</code>&#x53C2;&#x6570;&#x6765;&#x4FEE;&#x6539;&#x5BC6;&#x7801;&#xFF0C;&#x5982;<code>./mysqld_safe --skip-grant-tables &amp;</code>&#xFF0C;&#x7136;&#x540E;&#x518D;&#x767B;&#x5F55;mysql&#x8D26;&#x6237;&#x4FEE;&#x6539;&#x5BC6;&#x7801;&#x5373;&#x53EF;</p>
<h2 id="mysql&#x547D;&#x4EE4;&#x884C;&#x795E;&#x5668;mycli"><a name="mysql&#x547D;&#x4EE4;&#x884C;&#x795E;&#x5668;mycli" class="anchor-navigation-ex-anchor" href="#mysql&#x547D;&#x4EE4;&#x884C;&#x795E;&#x5668;mycli"><i class="fa fa-link" aria-hidden="true"></i></a>4.2. MySQL&#x547D;&#x4EE4;&#x884C;&#x795E;&#x5668;MyCLI</h2>
<blockquote>
<p>&#x5B98;&#x65B9;&#x7AD9;&#x70B9;&#xFF1A;<a href="https://www.mycli.net/" target="_blank">https://www.mycli.net/</a></p>
</blockquote>
<h3 id="&#x5B89;&#x88C5;"><a name="&#x5B89;&#x88C5;" class="anchor-navigation-ex-anchor" href="#&#x5B89;&#x88C5;"><i class="fa fa-link" aria-hidden="true"></i></a>4.2.1. &#x5B89;&#x88C5;</h3>
<p>&#x5728;RHEL/CentOS&#x4E0A;&#x5B89;&#x88C5;&#xFF1A;</p>
<pre class="language-"><code class="lang-bash"><span class="token function">sudo</span> yum <span class="token function">install</span> python-pip python-devel -y
<span class="token function">sudo</span> pip <span class="token function">install</span> mycli
</code></pre>
<p>&#x5728;Debian/Ubuntu&#x4E0A;&#x5B89;&#x88C5;&#xFF1A;</p>
<pre class="language-"><code class="lang-bash"><span class="token function">sudo</span> <span class="token function">apt</span> update
<span class="token function">sudo</span> <span class="token function">apt</span> <span class="token function">install</span> -y mycli
</code></pre>
<h3 id="&#x4F7F;&#x7528;"><a name="&#x4F7F;&#x7528;" class="anchor-navigation-ex-anchor" href="#&#x4F7F;&#x7528;"><i class="fa fa-link" aria-hidden="true"></i></a>4.2.2. &#x4F7F;&#x7528;</h3>
<p>&#x5728;&#x7EC8;&#x7AEF;&#x8F93;&#x5165;<code>mycli</code>&#x6307;&#x4EE4;&#x5916;&#x52A0;&#x4E0E;<code>mysql</code>&#x8FDE;&#x63A5;&#x5DE5;&#x5177;&#x76F8;&#x7C7B;&#x4F3C;&#x7684;&#x53C2;&#x6570;&#x5373;&#x53EF;&#xFF0C;&#x53EF;&#x4EE5;&#x4F7F;&#x7528;<code>mycli --help</code>&#x6765;&#x67E5;&#x770B;&#x5E2E;&#x52A9;.</p>
<h2 id="sql&#x5728;&#x7EBF;&#x7EC3;&#x4E60;&#x7F51;&#x7AD9;"><a name="sql&#x5728;&#x7EBF;&#x7EC3;&#x4E60;&#x7F51;&#x7AD9;" class="anchor-navigation-ex-anchor" href="#sql&#x5728;&#x7EBF;&#x7EC3;&#x4E60;&#x7F51;&#x7AD9;"><i class="fa fa-link" aria-hidden="true"></i></a>4.3. SQL&#x5728;&#x7EBF;&#x7EC3;&#x4E60;&#x7F51;&#x7AD9;</h2>
<p><a href="http://sqlfiddle.com/" target="_blank">http://sqlfiddle.com/</a> </p>
<footer class="page-footer"><span class="copyright">Copyright &#xA9; AGou 2020 all right reserved&#xFF0C;powered by Gitbook</span><span class="footer-modification">&#x8BE5;&#x6587;&#x4EF6;&#x4FEE;&#x8BA2;&#x65F6;&#x95F4;&#xFF1A;
2020-03-02 20:42:24
</span></footer>
                                
                                </section>
                            
    </div>
    <div class="search-results">
        <div class="has-results">
            
            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>
            
        </div>
        <div class="no-results">
            
            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
            
        </div>
    </div>
</div>

                        </div>
                    </div>
                
            </div>

            
                
                <a href="README.md" class="navigation navigation-prev " aria-label="Previous page: Mysql/MariaDB">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
                <a href="php-mysql.html" class="navigation navigation-next " aria-label="Next page: php-mysql">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
        
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"MySQL/MariaDB基础","level":"1.3.1.1","depth":3,"next":{"title":"php-mysql","level":"1.3.1.2","depth":3,"path":"Database/Mysql、MariaDB/php-mysql.md","ref":"Database/Mysql、MariaDB/php-mysql.md","articles":[]},"previous":{"title":"Mysql/MariaDB","level":"1.3.1","depth":2,"path":"Database/Mysql、MariaDB/README.md","ref":"Database/Mysql、MariaDB/README.md","articles":[{"title":"MySQL/MariaDB基础","level":"1.3.1.1","depth":3,"path":"Database/Mysql、MariaDB/MySQL、MariaDB基础.md","ref":"Database/Mysql、MariaDB/MySQL、MariaDB基础.md","articles":[]},{"title":"php-mysql","level":"1.3.1.2","depth":3,"path":"Database/Mysql、MariaDB/php-mysql.md","ref":"Database/Mysql、MariaDB/php-mysql.md","articles":[]}]},"dir":"ltr"},"config":{"plugins":["github@^2.0.0","edit-link@^2.0.2","anchors@^0.7.1","include-codeblock@^3.0.2","tbfed-pagefooter@^0.0.1","expandable-chapters-small@^0.1.7","anchor-navigation-ex@0.1.8","prism","-highlight","insert-logo","-lunr","-search","search-pro","splitter","lightbox","github-buttons","-sharing","sharing-plus","donate","code","-klipse","livereload"],"root":".","styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"pluginsConfig":{"tbfed-pagefooter":{"copyright":"Copyright © AGou 2020","modify_label":"该文件修订时间：","modify_format":"YYYY-MM-DD HH:mm:ss"},"prism":{"css":["prismjs/themes/prism-tomorrow.css"]},"github":{"url":"https://github.com/AGou-ops"},"livereload":{},"splitter":{},"search-pro":{},"sharing-plus":{"qq":false,"all":["facebook","google","twitter","instapaper","linkedin","pocket","stumbleupon"],"douban":false,"facebook":true,"weibo":false,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":true,"messenger":false,"line":false,"vk":false,"pocket":true,"google":false,"viber":false,"stumbleupon":false,"qzone":false,"linkedin":false},"code":{"copyButtons":true},"donate":{"alipay":"https://agou-ops.github.io/images/alipay.png","alipayText":"支付宝打赏","button":"打赏","title":"","wechat":"https://agou-ops.github.io/images/wechatpay.png","wechatText":"微信打赏"},"fontsettings":{"theme":"white","family":"sans","size":2},"anchor-navigation-ex":{"isRewritePageTitle":true,"tocLevel1Icon":"fa fa-hand-o-right","tocLevel2Icon":"fa fa-hand-o-right","tocLevel3Icon":"fa fa-hand-o-right"},"lightbox":{"jquery":true,"sameUuid":false},"github-buttons":{"repo":"AGou-ops/myStudyNote","types":["star","watch","fork"],"size":"small"},"expandable-chapters-small":{},"include-codeblock":{"check":false,"edit":true,"fixlang":false,"lang":"","template":"ace","theme":"chrome","unindent":true},"sharing":{"qq":true,"all":["douban","facebook","google","hatenaBookmark","instapaper","linkedin","twitter","weibo","messenger","qq","qzone","viber","vk","weibo","pocket","stumbleupon","whatsapp"],"douban":false,"facebook":false,"weibo":true,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":false,"messenger":false,"line":false,"vk":false,"pocket":false,"google":false,"viber":false,"stumbleupon":false,"qzone":true,"linkedin":false},"edit-link":{"label":"Edit This Page","base":"https://github.com/AGou-ops/myStudyNote"},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":true},"anchors":{},"insert-logo":{"style":"background: none; max-height: 50px; min-height: 50px","url":"https://s2.ax1x.com/2019/12/10/QBD0xO.jpg"}},"theme":"default","author":"AGou","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"AGou's StudyNote","language":"zh-hans","output.name":"site","links":{"sidebar":{"◆点击进入我的个人博客":"http://agou-ops.github.io"}},"gitbook":"3.2.3","description":"岂能尽如人意，但求无愧我心。"},"file":{"path":"Database/Mysql、MariaDB/MySQL、MariaDB基础.md","mtime":"2020-03-02T12:42:24.280Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2020-03-02T12:42:32.383Z"},"basePath":"../..","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="../../gitbook/gitbook.js"></script>
    <script src="../../gitbook/theme.js"></script>
    
        
        <script src="../../gitbook/gitbook-plugin-github/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-edit-link/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-expandable-chapters-small/expandable-chapters-small.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-insert-logo/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-search-pro/jquery.mark.min.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-search-pro/search.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-splitter/splitter.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-lightbox/js/lightbox.min.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-github-buttons/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-sharing-plus/buttons.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-donate/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-code/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-livereload/plugin.js"></script>
        
    
        
        <script src="../../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    

    </body>
</html>

